Problem Note 48485: SAS® Data Integration Studio shows only one Foreign Key Column if multiple foreign keys reference the same primary key table
 |  |  |  |  |
When you register a table containing two or more foreign keys that reference the same primary key table, only one Foreign Key Column is shown in SAS Data Integration Studio.
A SAS Data Integration Studio job that uses this table includes the following comment:
/* Foreign key definition in table table-name is incomplete. */
In SAS® Management Console, all foreign keys are shown.
You can work around this issue by deleting the foreign keys in SAS Management Console and adding them manually using SAS Data Integration Studio.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Data Integration Studio | Microsoft® Windows® for x64 | 4.2 | 4.3 | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 4.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 4.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.2 | 4.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 for x64 | 4.2 | 4.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2008 for x64 | 4.2 | 4.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows XP Professional | 4.2 | 4.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Windows Vista | 4.2 | 4.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Windows Vista for x64 | 4.2 | 4.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
A fix for this issue for SAS Data Integration Studio 4.21_M2 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/B51.html#48485| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2012-12-03 11:18:41 |
| Date Created: | 2012-11-16 07:16:05 |